Relatório de criação de perfil do Pandas

Dataset statistics

Number of variables	35
Number of observations	162273
Missing cells	42812
Missing cells (%)	0.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	43.3 MiB
Average record size in memory	280.0 B

Variable types

CAT	24
NUM	6
BOOL	4
DATE	1

Warnings

`horario` has a high cardinality: 1302 distinct values	High cardinality
`km` has a high cardinality: 7918 distinct values	High cardinality
`municipio` has a high cardinality: 1767 distinct values	High cardinality
`marca` has a high cardinality: 5555 distinct values	High cardinality
`latitude` has a high cardinality: 37312 distinct values	High cardinality
`longitude` has a high cardinality: 37317 distinct values	High cardinality
`delegacia` has a high cardinality: 173 distinct values	High cardinality
`uop` has a high cardinality: 86 distinct values	High cardinality
`pesid` is highly correlated with `id` and 1 other fields	High correlation
`id` is highly correlated with `pesid` and 1 other fields	High correlation
`id_veiculo` is highly correlated with `id` and 1 other fields	High correlation
`regional` is highly correlated with `uf` and 1 other fields	High correlation
`uf` is highly correlated with `regional` and 1 other fields	High correlation
`uop` is highly correlated with `uf` and 1 other fields	High correlation
`marca` has 8151 (5.0%) missing values	Missing
`ano_fabricacao_veiculo` has 9920 (6.1%) missing values	Missing
`idade` has 15759 (9.7%) missing values	Missing
`uop` has 8519 (5.2%) missing values	Missing
`idade` is highly skewed (γ1 = 29.83797844)	Skewed

Reproduction

Analysis started	2020-10-08 20:58:43.504038
Analysis finished	2020-10-08 21:00:05.672360
Duration	1 minute and 22.17 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	67446
Distinct (%)	41.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	221717.4169
Minimum	182210
Maximum	266627
Zeros	0
Zeros (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	182210
5-th percentile	186560.8
Q1	202070
median	221655
Q3	241471
95-th percentile	256881
Maximum	266627
Range	84417
Interquartile range (IQR)	39401

Descriptive statistics

Standard deviation	22637.1258
Coefficient of variation (CV)	0.1020989966
Kurtosis	-1.198925079
Mean	221717.4169
Median Absolute Deviation (MAD)	19699
Skewness	0.008371994235
Sum	3.597875039e+10
Variance	512439464.4
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200728	74	< 0.1%
230311	62	< 0.1%
228659	56	< 0.1%
215894	55	< 0.1%
192368	52	< 0.1%
264482	51	< 0.1%
221710	51	< 0.1%
202460	50	< 0.1%
255874	49	< 0.1%
255614	49	< 0.1%
Other values (67436)	161724	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
182210	4	< 0.1%
182211	1	< 0.1%
182212	1	< 0.1%
182214	1	< 0.1%
182215	2	< 0.1%

Value	Count	Frequency (%)
266627	1	< 0.1%
266573	1	< 0.1%
266434	2	< 0.1%
266406	3	< 0.1%
266255	2	< 0.1%

pesid
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	162272
Distinct (%)	100.0%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	492648.2693
Minimum	402087
Maximum	594393
Zeros	0
Zeros (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	402087
5-th percentile	412353.55
Q1	448657.75
median	493085.5
Q3	536997.25
95-th percentile	571369.45
Maximum	594393
Range	192306
Interquartile range (IQR)	88339.5

Descriptive statistics

Standard deviation	51063.88098
Coefficient of variation (CV)	0.1036518022
Kurtosis	-1.189998552
Mean	492648.2693
Median Absolute Deviation (MAD)	44173
Skewness	-0.01791316038
Sum	7.994301996e+10
Variance	2607519941
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
567380	1	< 0.1%
421783	1	< 0.1%
421788	1	< 0.1%
573646	1	< 0.1%
421787	1	< 0.1%
421786	1	< 0.1%
421785	1	< 0.1%
574012	1	< 0.1%
421784	1	< 0.1%
421782	1	< 0.1%
Other values (162262)	162262	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
402087	1	< 0.1%
402092	1	< 0.1%
402093	1	< 0.1%
402094	1	< 0.1%
402095	1	< 0.1%

Value	Count	Frequency (%)
594393	1	< 0.1%
594270	1	< 0.1%
594226	1	< 0.1%
593948	1	< 0.1%
593947	1	< 0.1%

data_inversa
Date

Distinct	365
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Minimum	2019-01-01 00:00:00
Maximum	2019-12-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

dia_semana
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

domingo	27930
sábado	27071
sexta-feira	25360
segunda-feira	21902
quinta-feira	20634
Other values (2)	39376

Frequencies
Length

Value	Count	Frequency (%)
domingo	27930	17.2%
sábado	27071	16.7%
sexta-feira	25360	15.6%
segunda-feira	21902	13.5%
quinta-feira	20634	12.7%
terça-feira	19770	12.2%
quarta-feira	19606	12.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	13
Median length	11
Mean length	9.995328859
Min length	6

horario
Categorical

HIGH CARDINALITY

Distinct	1302
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

18:30:00	2414
19:00:00	2400
18:00:00	2283
17:00:00	1870
19:30:00	1868
Other values (1297)	151438

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
18:30:00	2414	1.5%
19:00:00	2400	1.5%
18:00:00	2283	1.4%
17:00:00	1870	1.2%
19:30:00	1868	1.2%
16:00:00	1755	1.1%
17:30:00	1682	1.0%
16:30:00	1676	1.0%
07:00:00	1586	1.0%
07:30:00	1566	1.0%
Other values (1292)	143173	88.2%

Frequencies of value counts

Unique

Unique	79 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	8
Median length	8
Mean length	8
Min length	8

uf
Categorical

HIGH CORRELATION

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

MG	21380
SC	19574
PR	18259
RS	11425
RJ	10889
Other values (22)	80746

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
MG	21380	13.2%
SC	19574	12.1%
PR	18259	11.3%
RS	11425	7.0%
RJ	10889	6.7%
SP	10223	6.3%
BA	8888	5.5%
GO	8040	5.0%
ES	6581	4.1%
PE	6405	3.9%
Other values (17)	40609	25.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	2
Median length	2
Mean length	2
Min length	2

br
Real number (ℝ_≥0)

Distinct	115
Distinct (%)	0.1%
Missing	231
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%

Mean	217.4679713
Minimum	10
Maximum	495
Zeros	0
Zeros (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	10
5-th percentile	40
Q1	101
median	163
Q3	354
95-th percentile	470
Maximum	495
Range	485
Interquartile range (IQR)	253

Descriptive statistics

Standard deviation	132.0509173
Coefficient of variation (CV)	0.6072200724
Kurtosis	-1.16223415
Mean	217.4679713
Median Absolute Deviation (MAD)	99
Skewness	0.3898102809
Sum	35238945
Variance	17437.44475
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
101	25989	16.0%
116	22417	13.8%
381	7985	4.9%
40	7810	4.8%
153	6416	4.0%
364	5424	3.3%
163	4894	3.0%
277	4703	2.9%
470	4595	2.8%
262	4427	2.7%
Other values (105)	67382	41.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10	961	0.6%
20	2427	1.5%
30	14	< 0.1%
40	7810	4.8%
50	1452	0.9%

Value	Count	Frequency (%)
495	41	< 0.1%
493	624	0.4%
488	65	< 0.1%
487	52	< 0.1%
484	2	< 0.1%

km
Categorical

HIGH CARDINALITY

Distinct	7918
Distinct (%)	4.9%
Missing	231
Missing (%)	0.1%
Memory size	1.2 MiB

1	746
3	665
2	604
5	544
4	525
Other values (7913)	158958

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
1	746	0.5%
3	665	0.4%
2	604	0.4%
5	544	0.3%
4	525	0.3%
6	408	0.3%
7	354	0.2%
17	345	0.2%
9	320	0.2%
8	317	0.2%
Other values (7908)	157214	96.9%

Frequencies of value counts

Unique

Unique	459 ?
Unique (%)	0.3%

Histogram of lengths of the category

Length

Max length	6
Median length	3
Mean length	3.657422985
Min length	1

municipio
Categorical

HIGH CARDINALITY

Distinct	1767
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

BRASILIA	2727
CURITIBA	2514
SAO JOSE	1839
GUARULHOS	1711
SERRA	1492
Other values (1762)	151990

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
BRASILIA	2727	1.7%
CURITIBA	2514	1.5%
SAO JOSE	1839	1.1%
GUARULHOS	1711	1.1%
SERRA	1492	0.9%
PALHOCA	1360	0.8%
DUQUE DE CAXIAS	1357	0.8%
BETIM	1224	0.8%
PORTO VELHO	1137	0.7%
TERESINA	1072	0.7%
Other values (1757)	145840	89.9%

Frequencies of value counts

Unique

Unique	34 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	32
Median length	9
Mean length	10.59797995
Min length	3

causa_acidente
Categorical

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Falta de Atenção à Condução	60672
Desobediência às normas de trânsito pelo condutor	22239
Velocidade Incompatível	13370
Ingestão de Álcool	12646
Não guardar distância de segurança	12206
Other values (19)	41140

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Falta de Atenção à Condução	60672	37.4%
Desobediência às normas de trânsito pelo condutor	22239	13.7%
Velocidade Incompatível	13370	8.2%
Ingestão de Álcool	12646	7.8%
Não guardar distância de segurança	12206	7.5%
Defeito Mecânico no Veículo	7252	4.5%
Condutor Dormindo	5582	3.4%
Falta de Atenção do Pedestre	4651	2.9%
Pista Escorregadia	4535	2.8%
Ultrapassagem Indevida	3925	2.4%
Other values (14)	15195	9.4%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	78
Median length	27
Mean length	29.02841508
Min length	10

tipo_acidente
Categorical

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Colisão traseira	38070
Colisão transversal	23753
Colisão lateral	22902
Saída de leito carroçável	19582
Colisão frontal	15344
Other values (11)	42622

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Colisão traseira	38070	23.5%
Colisão transversal	23753	14.6%
Colisão lateral	22902	14.1%
Saída de leito carroçável	19582	12.1%
Colisão frontal	15344	9.5%
Atropelamento de Pedestre	8147	5.0%
Colisão com objeto estático	7893	4.9%
Tombamento	7463	4.6%
Queda de ocupante de veículo	4861	3.0%
Engavetamento	4580	2.8%
Other values (6)	9678	6.0%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	31
Median length	16
Mean length	18.23035872
Min length	8

classificacao_acidente
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Com Vítimas Feridas	125176
Sem Vítimas	22154
Com Vítimas Fatais	14943

Frequencies
Length

Value	Count	Frequency (%)
Com Vítimas Feridas	125176	77.1%
Sem Vítimas	22154	13.7%
Com Vítimas Fatais	14943	9.2%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	19
Median length	19
Mean length	17.81573028
Min length	11

fase_dia
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Pleno dia	89463
Plena Noite	55834
Anoitecer	9345
Amanhecer	7631

Frequencies
Length

Value	Count	Frequency (%)
Pleno dia	89463	55.1%
Plena Noite	55834	34.4%
Anoitecer	9345	5.8%
Amanhecer	7631	4.7%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	11
Median length	9
Mean length	9.688148984
Min length	9

sentido_via
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Crescente	87052
Decrescente	74990
Não Informado	231

Frequencies
Length

Value	Count	Frequency (%)
Crescente	87052	53.6%
Decrescente	74990	46.2%
Não Informado	231	0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	13
Median length	9
Mean length	9.929939053
Min length	9

condicao_metereologica
Categorical

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Céu Claro	94822
Nublado	27464
Chuva	17510
Sol	12956
Garoa/Chuvisco	5535
Other values (5)	3986

Frequencies
Length

Value	Count	Frequency (%)
Céu Claro	94822	58.4%
Nublado	27464	16.9%
Chuva	17510	10.8%
Sol	12956	8.0%
Garoa/Chuvisco	5535	3.4%
Ignorado	2126	1.3%
Nevoeiro/Neblina	1525	0.9%
Vento	327	0.2%
Granizo	7	< 0.1%
Neve	1	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	16
Median length	9
Mean length	7.965896976
Min length	3

tipo_pista
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Simples	85939
Dupla	63688
Múltipla	12646

Frequencies
Length

Value	Count	Frequency (%)
Simples	85939	53.0%
Dupla	63688	39.2%
Múltipla	12646	7.8%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	8
Median length	7
Mean length	6.29298158
Min length	5

tracado_via
Categorical

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Reta	101632
Curva	22973
Não Informado	18373
Interseção de vias	8132
Desvio Temporário	4268
Other values (5)	6895

Frequencies
Length

Value	Count	Frequency (%)
Reta	101632	62.6%
Curva	22973	14.2%
Não Informado	18373	11.3%
Interseção de vias	8132	5.0%
Desvio Temporário	4268	2.6%
Rotatória	2993	1.8%
Retorno Regulamentado	1836	1.1%
Viaduto	1008	0.6%
Ponte	901	0.6%
Túnel	157	0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	21
Median length	4
Mean length	6.513794655
Min length	4

uso_solo
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Não	90021
Sim	72252

Frequencies
Length

Value	Count	Frequency (%)
Não	90021	55.5%
Sim	72252	44.5%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	3
Min length	3

id_veiculo
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	112051
Distinct (%)	69.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	395616.163
Minimum	324863
Maximum	475775
Zeros	0
Zeros (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	324863
5-th percentile	331763
Q1	360260
median	395854
Q3	431382
95-th percentile	458651
Maximum	475775
Range	150912
Interquartile range (IQR)	71122

Descriptive statistics

Standard deviation	40807.36381
Coefficient of variation (CV)	0.1031488792
Kurtosis	-1.203031293
Mean	395616.163
Median Absolute Deviation (MAD)	35559
Skewness	-0.008449811909
Sum	6.419782162e+10
Variance	1665240941
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
411506	62	< 0.1%
385122	54	< 0.1%
410028	54	< 0.1%
342242	52	< 0.1%
395920	51	< 0.1%
360867	50	< 0.1%
471780	50	< 0.1%
456769	48	< 0.1%
456298	47	< 0.1%
440584	47	< 0.1%
Other values (112041)	161758	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
324863	1	< 0.1%
324868	1	< 0.1%
324871	2	< 0.1%
324872	2	< 0.1%
324875	1	< 0.1%

Value	Count	Frequency (%)
475775	1	< 0.1%
475680	1	< 0.1%
475416	1	< 0.1%
475415	1	< 0.1%
475372	1	< 0.1%

tipo_veiculo
Categorical

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Automóvel	70650
Motocicleta	31858
Caminhonete	14228
Caminhão-trator	12068
Caminhão	11517
Other values (19)	21952

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Automóvel	70650	43.5%
Motocicleta	31858	19.6%
Caminhonete	14228	8.8%
Caminhão-trator	12068	7.4%
Caminhão	11517	7.1%
Ônibus	7054	4.3%
Camioneta	4160	2.6%
Motoneta	3746	2.3%
Bicicleta	2086	1.3%
Utilitário	1900	1.2%
Other values (14)	3006	1.9%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	17
Median length	9
Mean length	9.828326339
Min length	6

marca
Categorical

HIGH CARDINALITY
MISSING

Distinct	5555
Distinct (%)	3.6%
Missing	8151
Missing (%)	5.0%
Memory size	1.2 MiB

VW/GOL 1.0	1984
HONDA/CG 125 FAN KS	1673
HONDA/CG 150 TITAN KS	1543
MBENZ/MPOLO PARADISO R	1508
HONDA/CG 150 FAN ESI	1353
Other values (5550)	146061

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
VW/GOL 1.0	1984	1.2%
HONDA/CG 125 FAN KS	1673	1.0%
HONDA/CG 150 TITAN KS	1543	1.0%
MBENZ/MPOLO PARADISO R	1508	0.9%
HONDA/CG 150 FAN ESI	1353	0.8%
HONDA/BIZ 125 ES	1250	0.8%
HONDA/CG150 FAN ESDI	1202	0.7%
HONDA/CG 150 TITAN ESD	969	0.6%
HONDA/CB 300R	954	0.6%
HONDA/CG 125 FAN	932	0.6%
Other values (5545)	140754	86.7%
(Missing)	8151	5.0%

Frequencies of value counts

Unique

Unique	1209 ?
Unique (%)	0.8%

Histogram of lengths of the category

Length

Max length	25
Median length	19
Mean length	17.95007796
Min length	3

ano_fabricacao_veiculo
Real number (ℝ_≥0)

MISSING

Distinct	63
Distinct (%)	< 0.1%
Missing	9920
Missing (%)	6.1%
Infinite	0
Infinite (%)	0.0%

Mean	2009.417799
Minimum	1900
Maximum	2019
Zeros	0
Zeros (%)	0.0%
Memory size	1.2 MiB

Quantile statistics

Minimum	1900
5-th percentile	1995
Q1	2007
median	2011
Q3	2014
95-th percentile	2018
Maximum	2019
Range	119
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	7.536433426
Coefficient of variation (CV)	0.003750555722
Kurtosis	7.773418505
Mean	2009.417799
Median Absolute Deviation (MAD)	4
Skewness	-1.823216284
Sum	306140830
Variance	56.79782879
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2013	12048	7.4%
2011	11819	7.3%
2018	10852	6.7%
2014	10827	6.7%
2012	10385	6.4%
2010	10282	6.3%
2008	8403	5.2%
2009	7966	4.9%
2015	7585	4.7%
2017	7499	4.6%
Other values (53)	54687	33.7%
(Missing)	9920	6.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1900	15	< 0.1%
1951	1	< 0.1%
1958	3	< 0.1%
1960	1	< 0.1%
1961	3	< 0.1%

Value	Count	Frequency (%)
2019	4434	2.7%
2018	10852	6.7%
2017	7499	4.6%
2016	6139	3.8%
2015	7585	4.7%

tipo_envolvido
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Condutor	112035
Passageiro	43241
Pedestre	3708
Testemunha	3240
Cavaleiro	48

Frequencies
Length

Value	Count	Frequency (%)
Condutor	112035	69.0%
Passageiro	43241	26.6%
Pedestre	3708	2.3%
Testemunha	3240	2.0%
Cavaleiro	48	< 0.1%
Não Informado	1	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	13
Median length	8
Mean length	8.573200717
Min length	8

estado_fisico
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Ileso	68634
Lesões Leves	60500
Lesões Graves	18573
Não Informado	9233
Óbito	5333

Frequencies
Length

Value	Count	Frequency (%)
Ileso	68634	42.3%
Lesões Leves	60500	37.3%
Lesões Graves	18573	11.4%
Não Informado	9233	5.7%
Óbito	5333	3.3%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	13
Median length	12
Mean length	8.980625243
Min length	5

idade
Real number (ℝ_≥0)

MISSING
SKEWED

Distinct	122
Distinct (%)	0.1%
Missing	15759
Missing (%)	9.7%
Infinite	0
Infinite (%)	0.0%

Mean	39.87971115
Minimum	0
Maximum	2018
Zeros	318
Zeros (%)	0.2%
Memory size	1.2 MiB

Quantile statistics

Minimum	0
5-th percentile	17
Q1	27
median	37
Q3	48
95-th percentile	65
Maximum	2018
Range	2018
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	51.42658978
Coefficient of variation (CV)	1.289542685
Kurtosis	1050.092838
Mean	39.87971115
Median Absolute Deviation (MAD)	10
Skewness	29.83797844
Sum	5842936
Variance	2644.694137
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38	4013	2.5%
37	3859	2.4%
32	3856	2.4%
33	3851	2.4%
36	3828	2.4%
30	3814	2.4%
34	3799	2.3%
35	3781	2.3%
31	3781	2.3%
26	3701	2.3%
Other values (112)	108231	66.7%
(Missing)	15759	9.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	318	0.2%
1	327	0.2%
2	308	0.2%
3	313	0.2%
4	337	0.2%

Value	Count	Frequency (%)
2018	51	< 0.1%
2017	2	< 0.1%
1919	1	< 0.1%
1918	12	< 0.1%
1908	3	< 0.1%

sexo
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Masculino	114781
Feminino	37155
Não Informado	9233
Ignorado	1104

Frequencies
Length

Value	Count	Frequency (%)
Masculino	114781	70.7%
Feminino	37155	22.9%
Não Informado	9233	5.7%
Ignorado	1104	0.7%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	13
Median length	9
Mean length	8.991822423
Min length	8

ilesos
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

0	93639
1	68634

Common Values
Chart

Value	Count	Frequency (%)
0	93639	57.7%
1	68634	42.3%

feridos_leves
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

0	101773
1	60500

Common Values
Chart

Value	Count	Frequency (%)
0	101773	62.7%
1	60500	37.3%

feridos_graves
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

0	143700
1	18573

Common Values
Chart

Value	Count	Frequency (%)
0	143700	88.6%
1	18573	11.4%

mortos
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

0	156940
1	5333

Common Values
Chart

Value	Count	Frequency (%)
0	156940	96.7%
1	5333	3.3%

latitude
Categorical

HIGH CARDINALITY

Distinct	37312
Distinct (%)	23.0%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

-27,59193546	211
-8,766685	184
-27,61000542	157
-5,089569	153
-27,63697369	152
Other values (37307)	161416

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
-27,59193546	211	0.1%
-8,766685	184	0.1%
-27,61000542	157	0.1%
-5,089569	153	0.1%
-27,63697369	152	0.1%
-27,60327979	151	0.1%
-3,76999035	147	0.1%
-27,600384	136	0.1%
-20,21740496	133	0.1%
-27,64443	123	0.1%
Other values (37302)	160726	99.0%

Frequencies of value counts

Unique

Unique	7691 ?
Unique (%)	4.7%

Histogram of lengths of the category

Length

Max length	14
Median length	11
Mean length	10.86825904
Min length	2

longitude
Categorical

HIGH CARDINALITY

Distinct	37317
Distinct (%)	23.0%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

-48,61824557	211
-63,884052	184
-48,63895057	157
-42,802288	153
-48,66514142	152
Other values (37312)	161416

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
-48,61824557	211	0.1%
-63,884052	184	0.1%
-48,63895057	157	0.1%
-42,802288	153	0.1%
-48,66514142	152	0.1%
-48,63201818	151	0.1%
-38,67006282	147	0.1%
-48,599705	136	0.1%
-40,26990578	133	0.1%
-48,67057	123	0.1%
Other values (37307)	160726	99.0%

Frequencies of value counts

Unique

Unique	7679 ?
Unique (%)	4.7%

Histogram of lengths of the category

Length

Max length	14
Median length	12
Mean length	11.05523408
Min length	3

regional
Categorical

HIGH CORRELATION

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

SR-MG	21350
SR-SC	19656
SR-PR	18162
SR-RS	11444
SR-RJ	10881
Other values (23)	80780

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
SR-MG	21350	13.2%
SR-SC	19656	12.1%
SR-PR	18162	11.2%
SR-RS	11444	7.1%
SR-RJ	10881	6.7%
SR-SP	10210	6.3%
SR-BA	8770	5.4%
SR-ES	6581	4.1%
SR-PE	6516	4.0%
SR-DF	5427	3.3%
Other values (18)	43276	26.7%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	13
Median length	5
Mean length	5.000394397
Min length	5

delegacia
Categorical

HIGH CARDINALITY

Distinct	173
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

DEL7/1	7196
DEL8/4	5655
DEL8/1	4696
DEL4/1	4398
DEL7/7	4299
Other values (168)	136029

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
DEL7/1	7196	4.4%
DEL8/4	5655	3.5%
DEL8/1	4696	2.9%
DEL4/1	4398	2.7%
DEL7/7	4299	2.6%
DEL11/1	3479	2.1%
DEL5/1	2905	1.8%
DEL8/3	2561	1.6%
DEL16/1	2403	1.5%
DEL7	2363	1.5%
Other values (163)	122318	75.4%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	14
Median length	6
Mean length	6.405526489
Min length	2

uop
Categorical

HIGH CARDINALITY
HIGH CORRELATION
MISSING

Distinct	86
Distinct (%)	0.1%
Missing	8519
Missing (%)	5.2%
Memory size	1.2 MiB

UOP01/MG	9394
UOP01/SC	7524
UOP01/SP	6289
UOP02/MG	5871
UOP01/BA	5844
Other values (81)	118832

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
UOP01/MG	9394	5.8%
UOP01/SC	7524	4.6%
UOP01/SP	6289	3.9%
UOP02/MG	5871	3.6%
UOP01/BA	5844	3.6%
UOP01/RS	5631	3.5%
UOP03/MG	5194	3.2%
UOP01/ES	5091	3.1%
UOP02/SC	4788	3.0%
UOP03/SC	4660	2.9%
Other values (76)	93468	57.6%
(Missing)	8519	5.2%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	8
Median length	8
Mean length	7.737362346
Min length	2

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	id	pesid	data_inversa	dia_semana	horario	uf	br	km	municipio	causa_acidente	tipo_acidente	classificacao_acidente	fase_dia	sentido_via	condicao_metereologica	tipo_pista	tracado_via	uso_solo	id_veiculo	tipo_veiculo	marca	ano_fabricacao_veiculo	tipo_envolvido	estado_fisico	idade	sexo	ilesos	feridos_leves	feridos_graves	latitude	longitude	regional	delegacia	uop
0	182256.0	403856.0	2019-01-01	terça-feira	04:00:00	CE	116.0	136,9	RUSSAS	Animais na Pista	Atropelamento de Animal	Sem Vítimas	Amanhecer	Decrescente	Vento	Simples	Curva	Não	324937	Caminhão	I/MB 15SPRINT RONTAN AMB	2012.0	Condutor	Ileso	35.0	Masculino	1	0	0	-4,766018	-38,056034	SR-CE	DEL16/3	UOP01/CE
1	182263.0	402859.0	2019-01-01	terça-feira	05:00:00	MT	158.0	599,5	AGUA BOA	Defeito Mecânico no Veículo	Incêndio	Sem Vítimas	Amanhecer	Decrescente	Garoa/Chuvisco	Simples	Reta	Não	324940	Caminhão	FORD/CARGO 815 N	2011.0	Condutor	Ileso	30.0	Masculino	1	0	0	-14,319	-52,169	SR-MT	DEL2/8	UOP02/MT
2	182277.0	402850.0	2019-01-01	terça-feira	10:00:00	PA	10.0	34	DOM ELISEU	Velocidade Incompatível	Colisão traseira	Sem Vítimas	Pleno dia	Decrescente	Nublado	Simples	Não Informado	Não	324958	Caminhão-trator	VOLVO/FH 540 6X4T	2012.0	Condutor	Ileso	54.0	Masculino	1	0	0	-4,15296734	-47,54608154	SR-PA	DEL19/2	UOP03/PA
3	182289.0	402431.0	2019-01-01	terça-feira	08:30:00	BA	101.0	13	RIO REAL	Ingestão de Álcool	Colisão traseira	Com Vítimas Feridas	Pleno dia	Decrescente	Céu Claro	Dupla	Desvio Temporário	Não	324987	Caminhão-trator	SCANIA/R 440 A6X2	2018.0	Condutor	Ileso	43.0	Masculino	1	0	0	-11,5896	-37,8761	SR-SE	DEL20/2	UOP03/SE
4	182307.0	402642.0	2019-01-01	terça-feira	13:50:00	BA	116.0	440	FEIRA DE SANTANA	Ingestão de Álcool	Saída de leito carroçável	Com Vítimas Feridas	Pleno dia	Decrescente	Céu Claro	Dupla	Curva	Não	325030	Caminhão-trator	VOLVO/FH12 380 4X2T	2003.0	Passageiro	Lesões Graves	37.0	Masculino	0	0	1	-12,344	-39,087	SR-BA	DEL10/2	UOP01/BA
5	182307.0	402638.0	2019-01-01	terça-feira	13:50:00	BA	116.0	440	FEIRA DE SANTANA	Ingestão de Álcool	Saída de leito carroçável	Com Vítimas Feridas	Pleno dia	Decrescente	Céu Claro	Dupla	Curva	Não	325030	Caminhão-trator	VOLVO/FH12 380 4X2T	2003.0	Condutor	Lesões Leves	57.0	Masculino	0	1	0	-12,344	-39,087	SR-BA	DEL10/2	UOP01/BA
6	182316.0	402361.0	2019-01-01	terça-feira	15:15:00	RS	101.0	8	TORRES	Falta de Atenção à Condução	Tombamento	Sem Vítimas	Pleno dia	Crescente	Céu Claro	Dupla	Reta	Sim	325039	Caminhão-trator	SCANIA/R124 GA6X4NZ 420	2004.0	Condutor	Ileso	28.0	Masculino	1	0	0	-29,360483	-49,807865	SR-RS	DEL9/3	UOP03/RS
7	182334.0	402401.0	2019-01-01	terça-feira	14:45:00	SE	101.0	76,7	MARUIM	Falta de Atenção à Condução	Saída de leito carroçável	Com Vítimas Feridas	Pleno dia	Crescente	Sol	Simples	Reta	Não	325068	Caminhão	IVECO/TECTOR 240E25	2010.0	Condutor	Não Informado	NaN	Não Informado	0	0	0	-10,7853	-37,1421	SR-SE	DEL20/1	UOP01/SE
8	182361.0	402521.0	2019-01-01	terça-feira	10:00:00	MG	251.0	280	SALINAS	Ultrapassagem Indevida	Saída de leito carroçável	Com Vítimas Feridas	Pleno dia	Decrescente	Sol	Simples	Reta	Não	325052	Caminhão-trator	VOLVO/FH 440 6X2T	2011.0	Condutor	Lesões Leves	52.0	Masculino	0	1	0	-16,12498503	-42,22251892	SR-MG	DEL4/11	UOP02/MG
9	182362.0	404322.0	2019-01-01	terça-feira	18:20:00	PE	101.0	41	IGARASSU	Ingestão de Álcool	Colisão lateral	Sem Vítimas	Plena Noite	Crescente	Céu Claro	Dupla	Reta	Sim	325208	Caminhão	VW/8.140	1999.0	Condutor	Ileso	59.0	Masculino	1	0	0	-7,837	-34,9124	SR-PE	DEL11/1	UOP02/PE

Last rows

	id	pesid	data_inversa	dia_semana	horario	uf	br	km	municipio	causa_acidente	tipo_acidente	classificacao_acidente	fase_dia	sentido_via	condicao_metereologica	tipo_pista	tracado_via	uso_solo	id_veiculo	tipo_veiculo	marca	ano_fabricacao_veiculo	tipo_envolvido	estado_fisico	idade	sexo	ilesos	feridos_leves	feridos_graves	latitude	longitude	regional	delegacia	uop
162263	266158.0	593481.0	2019-01-15	terça-feira	05:00:00	AC	364.0	130	RIO BRANCO	Defeito na Via	Queda de ocupante de veículo	Com Vítimas Feridas	Amanhecer	Crescente	Ignorado	Dupla	Reta	Sim	474988	Motocicleta	HONDA/CG 150 TITAN ESD	2013.0	Condutor	Lesões Graves	NaN	Masculino	0	0	1	-10,0131571	-67,7137847	SR-AC	UOP01/AC	NaN
162264	266255.0	593651.0	2019-10-07	segunda-feira	09:10:00	ES	101.0	270,5	SERRA	Falta de Atenção à Condução	Tombamento	Com Vítimas Feridas	Pleno dia	Crescente	Céu Claro	Dupla	Reta	Sim	475144	Motocicleta	HONDA/CB 300R	2015.0	Condutor	Lesões Graves	NaN	Masculino	0	0	1	-20,23106874	-40,27387446	SR-ES	DEL12/2	UOP01/ES
162265	266255.0	593652.0	2019-10-07	segunda-feira	09:10:00	ES	101.0	270,5	SERRA	Falta de Atenção à Condução	Tombamento	Com Vítimas Feridas	Pleno dia	Crescente	Céu Claro	Dupla	Reta	Sim	475146	Outros	NaN	NaN	Condutor	Ileso	NaN	Ignorado	1	0	0	-20,23106874	-40,27387446	SR-ES	DEL12/2	UOP01/ES
162266	266406.0	593905.0	2019-11-25	segunda-feira	07:20:00	PR	116.0	125	FAZENDA RIO GRANDE	Falta de Atenção à Condução	Colisão lateral	Com Vítimas Feridas	Pleno dia	Decrescente	Céu Claro	Dupla	Reta	Sim	475372	Micro-ônibus	NaN	NaN	Condutor	Não Informado	NaN	Não Informado	0	0	0	-25,59505309	-49,31630659	SR-PR	DEL7/1	UOP03/PR
162267	266406.0	593903.0	2019-11-25	segunda-feira	07:20:00	PR	116.0	125	FAZENDA RIO GRANDE	Falta de Atenção à Condução	Colisão lateral	Com Vítimas Feridas	Pleno dia	Decrescente	Céu Claro	Dupla	Reta	Sim	475370	Motocicleta	HONDA/CG 150 TITAN KS	2006.0	Passageiro	Ileso	25.0	Masculino	1	0	0	-25,59505309	-49,31630659	SR-PR	DEL7/1	UOP03/PR
162268	266406.0	593902.0	2019-11-25	segunda-feira	07:20:00	PR	116.0	125	FAZENDA RIO GRANDE	Falta de Atenção à Condução	Colisão lateral	Com Vítimas Feridas	Pleno dia	Decrescente	Céu Claro	Dupla	Reta	Sim	475370	Motocicleta	HONDA/CG 150 TITAN KS	2006.0	Condutor	Lesões Leves	44.0	Masculino	0	1	0	-25,59505309	-49,31630659	SR-PR	DEL7/1	UOP03/PR
162269	266434.0	593948.0	2019-06-03	segunda-feira	19:00:00	CE	222.0	1,4	CAUCAIA	Não guardar distância de segurança	Colisão traseira	Com Vítimas Feridas	Plena Noite	Crescente	Céu Claro	Dupla	Reta	Sim	475416	Automóvel	FIAT/UNO MILLE WAY ECON	2009.0	Condutor	Lesões Graves	41.0	Masculino	0	0	1	-3,736507	-38,65337	SR-CE	DEL16/1	UOP01/CE
162270	266434.0	593947.0	2019-06-03	segunda-feira	19:00:00	CE	222.0	1,4	CAUCAIA	Não guardar distância de segurança	Colisão traseira	Com Vítimas Feridas	Plena Noite	Crescente	Céu Claro	Dupla	Reta	Sim	475415	Automóvel	VW/GOLF 1.6 SPORTLINE	2011.0	Condutor	Ileso	36.0	Masculino	1	0	0	-3,736507	-38,65337	SR-CE	DEL16/1	UOP01/CE
162271	266573.0	594270.0	2019-07-13	sábado	19:35:00	PR	373.0	425	CANDOI	Defeito Mecânico no Veículo	Saída de leito carroçável	Com Vítimas Feridas	Plena Noite	Decrescente	Ignorado	Simples	Reta	Não	475680	Automóvel	VW/VOYAGE 1.6	NaN	Condutor	Lesões Graves	NaN	Masculino	0	0	1	-25,71180139	-52,18373987	SR-PR	DEL7/3	UOP02/PR
162272	266627.0	594393.0	2019-10-22	terça-feira	20:20:00	BA	324.0	608	SIMOES FILHO	Defeito na Via	Queda de ocupante de veículo	Com Vítimas Feridas	Plena Noite	Crescente	Céu Claro	Simples	Reta	Não	475775	Motocicleta	YAMAHA/MT03	2016.0	Condutor	Lesões Leves	NaN	Masculino	0	1	0	-12,78155812	-38,41655733	SR-BA	DEL10/1	UOP01/BA

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows